Dashboard 03 & 04 - ZipCode & Township Dashboard - Creating Cards and Slicer 21


Next, in order to get you started, copy the cards and slicer visualizations from the 2nd dashboard, WakeCountyRealEstate



Visualizations

To copy and paste the visualizations, click on the first visual, and while holding the Ctrl key, select (left-click) on the following cards and slicer:

Years
AVG House Price
AVG House Price/Sq.Ft.
YOY AVG Hse Price/Sq.Ft.
AVG Price House Price/Sq.Ft.
YOY AVG Apt Price/Sq.Ft.


To create a copy of the visuals, press Ctrl+C to copy, and then press Ctrl+V to paste

Paste the visuals to the following dashboards:

ZipCode
Township





Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

In the ZipCode dashboard, set as follows:

To format the visual, beneath the Visualizations pane, select the Format pane.

Years
Under Format ->  General: X Position = 1020 , Y Position = 0 , Width = 300 , Height = 121


AVG House Price
Under Format ->  General: X Position = 0 , Y Position = 254 , Width = 272 , Height = 154


AVG House Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 408 , Width = 272 , Height = 154


YOY AVG Hse Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 563 , Width = 272 , Height = 156


AVG Price House Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 718 , Width = 272 , Height = 156


YOY AVG Apt Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 874 , Width = 272 , Height = 154



Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Delete AVG House Price card from the Township dashboard

The AVG House Price card is not included in the last Township dashboard.  Delete it prior to setting the size and location of the cards.

In the Township dashboard, set as follows:

To format the visual, beneath the Visualizations pane, select the Format pane.

Years
Under Format ->  General: X Position = 1020 , Y Position = 0 , Width = 300 , Height = 121


AVG House Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 406 , Width = 273 , Height = 156


YOY AVG Hse Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 562 , Width = 273 , Height = 154


AVG Price House Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 717 , Width = 273 , Height = 156


YOY AVG Apt Price/Sq.Ft.
Under Format ->  General: X Position = 0 , Y Position = 872 , Width = 273 , Height = 156




When finished, save project.

How to create a Slicer visualization in Power BI